ORDER BY question

Поиск
Список
Период
Сортировка
От Charles Hauser
Тема ORDER BY question
Дата
Msg-id a05010403b819f5e7857d@[152.3.11.193]
обсуждение исходный текст
Ответы Re: ORDER BY question  (Masaru Sugawara <rk73@echna.ne.jp>)
Re: ORDER BY question  ("Andrew G. Hammond" <drew@xyzzy.dhs.org>)
Список pgsql-sql
Hope this is the correct forum - if not sorry.

I have a query which returns a value of the form: '20010822.1338.1'.

I would like to order the results, sorting :
    1st: 20010822    2nd: 1338    3rd: 1


I can do this in perl, but have not found a way to do this using ORDER BY.

I am VERY new to DB's; biologist trying to do informatics.

Thanks.
-- 
Chuck


В списке pgsql-sql по дате отправления:

Предыдущее
От: Jason Earl
Дата:
Сообщение: Re: Optimization with dates
Следующее
От: dinocherian@yahoo.com (dino ck)
Дата:
Сообщение: How to return more than one row of data from a function in PL/pgSQL